<?php session_start(); ?>
<?php include "libfunc.php";?>
<?php if (!empty($_SESSION['admUser']) && !empty($_SESSION['admPass'])) { ?>
<html>
 <head>
  <title>.: Admin Room Toko Buku Bekas :.</title>
  <link href="admInc/cssMainStyle.css" type="text/css" rel="stylesheet">
  <link href="admInc/cssTableStyle.css" type="text/css" rel="stylesheet">
  <link href="admInc/cssAdditionStyle.css" type="text/css" rel="stylesheet">
  <link href="admInc/cssTableNavigation.css" type="text/css" rel="stylesheet">
 </head>
 <body class="fix">
  <div id="wrapper">
   <div id="header">
    <div class="titleHeader"><center>
     <img src="image/logo2.png" border="0">
	</div><!-- titleHeader //-->
	<div class="subTitleHeader"><center>
	 - Website Administrator Control Panel -
	</div><!-- subTitleHeader //-->
   </div><!-- header //--></center>
   <div id="mainContent">
    <div id="leftColumn">
	 <div class="navigation">
	  <table border="0" width="100%" bgcolor="white">
	  <tr>
	    <td class="headerTable" align="center"><b>Admin Page</b></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="adminLayout.php"> Halaman Utama</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="newInformation.php"> Informasi Terkini</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="LogOut.php" onClick="return confirm('Apakah Anda benar-benar akan keluar dari halaman Admin ?')"> Keluar</a></td>
	  </tr>
	  <tr>
	    <td></td>
	  </tr>
	  <tr>
	    <td></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
	  <tr>
	    <td class="headerTable" align="center"><b>Data Kategori</b></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="tambah_kategori.php"> Tambah Kategori</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="view_kategori.php"> View Kategori</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="pencarian_kategori.php"> Pencarian Kategori</a></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
	  <tr>
	    <td class="headerTable" align="center"><b>Data Member</b></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="tambah_member.php"> Tambah Member</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="view_member.php"> View Member</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="pencarian_member.php"> Pencarian Member</a></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
	  <tr>
	    <td class="headerTable" align="center"><b>Data Produk</b></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="tambah_produk.php"> Tambah Produk</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="view_produk.php"> View Produk</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="pencarian_produk.php"> Pencarian Produk</a></td>
	  </tr>
	  <tr>
		<td></td>
	  </tr>
	  <tr>
		<td></td>
	  </tr>
	  <tr>
	    <td class="headerTable" align="center"><b>Data Request Produk</b></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="view_request.php"> View Request</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="pencarian_request.php"> Pencarian Request</a></td>
	  </tr>
	  <tr>
		<td></td>
	  </tr>
	  <tr>
		<td></td>
	  </tr>
	  <tr>
	    <td class="headerTable" align="center"><b>Data Pesanan</b></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="view_pesanan.php"> View Pesanan</a></td>
	  </tr>
	  <tr>
	    <td><img src="image/tag_blue.png"><a href="pencarian_pesanan.php"> Pencarian Pesanan</a></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
      <tr>
	    <td></td>
	  </tr>
	</table>
	 </div><!-- navigation //-->
	</div><!-- leftColumn //-->
	<div id="rightColumn">
	 <div class="content">
		<?php 
		  $file   = "view_pesanan.php";
		  include "class_paging.php";
		  $p      = new Paging;
		  $batas  = 5;
		  $posisi = $p->cariPosisi($batas);
		
		  $link = koneksi_db();
		  $sql  = "select * from dtpesanan limit $posisi,$batas";
		  $res  = mysql_query($sql,$link);
		  $sql2 = "select * from dtpesanan";
		  $res2 =  mysql_query($sql2);
		  $jmlrecord = mysql_num_rows($res2);
		  $jmlhalaman = $p->jumlahHalaman($jmlrecord,$batas);
		
		if($jmlrecord > 0){
		?>
         <fieldset>
          <legend>View Data Pesanan</legend>
		   <table align='center' class="tableView">
		    <tr class="trTable">
		     <td>NO</td>
		   	 <td>ID Pesanan</td>
			 <td>Nama Member</td>
			 <td>Waktu Pesanan</td>
			 <td>Dichekout</td>
			 <td>Diarsipkan</td>
			 <td>Aksi</td>
		    </tr>
	  <?php
	     $no = $posisi+1;
		 while( $data = mysql_fetch_array($res) ){
		   ?>
		    <tr>
		     <td><?php echo $no; ?></td>
			 <td><?php echo $data['Id_pesanan']; ?></td>
			 <td>
			   <?php
			     $sql_p =  "select dtmember.nama from dtmember,dtpesanan
				 		    where dtmember.id_member = dtpesanan.id_member
							and
							dtmember.id_member = '$data[id_member]'
							";
				 $query_p = mysql_query($sql_p,$link);
				 $hasil_p = mysql_fetch_array($query_p);
				 
				 echo $hasil_p['nama'];
			   ?>
             </td>
			 <td>
			   <?php 
			   	  echo $data['waktu'];
			   ?>
             </td>
			 <td>
				<?php 
					if ($data['dichekout']=='T') {
						echo "Belum";
					}else{
						echo "Sudah";
					}
				?>
			 </td>
			 <td>
				<?php 
					if ($data['diarsipkan']=='T') {
						echo "Belum";
					}else{
						echo "Sudah";
					}
				?>
			 </td>
			 <td align="center">
				<a href="detail_pesanan.php?id=<?php echo $data['Id_pesanan']; ?>&idm=<?php echo $data['id_member']; ?>"><img src="image/magnifier.png" border="0" title="Lihat !"></a>
			 </td>
            </tr>
		 <?php
		    $no++;
		 }?>
           </table><br><br>
         <span class="paging">
      <?php
	    $linkHalaman = $p->navHalaman($_GET[halaman],$jmlhalaman);
		echo $linkHalaman;
	  ?>
      	</span>
		 </fieldset>
         <div id='keterangan'>
       	 <fieldset>
          <legend>Keterangan</legend>
         	Data Pesanan Buku,,Silakan Dilihat !!!
       	  </fieldset>
     	 </div>
         <?php
	  }else{
	    echo "
		  </table>
		 </fieldset>
         <div id='keterangan'>
       		<fieldset>
         	<legend>Keterangan</legend>
         	Data Buku Kosong, Silakan Isi Terlebih Dahulu!!
       		</fieldset>
     	 </div>
		";
	  }
	  ?>
	 </div><!-- content //-->
     <div id="keterangan">
	 <br>
	 </br>
       
     </div>
	</div><!-- rightColumn //-->
   </div><!-- mainContent //-->
  </div><!-- wrapper //-->
 </body>
</html>
<?php
}else{
  echo "<script language='javascript'>alert('Silakan Sign In Terlebih Dahulu')</script>";
  echo "<script language='javascript'>window.location = '../admin/'</script>";
}